package com.tnr.scgcxx.dao.info;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.dq.base.page.PageParam;

import com.tnr.scgcxx.dto.ColorDto;
import com.tnr.scgcxx.model.Color;

public interface ColorDao {
	
	@Select("select co_id,co_name,co_remark,co_status from info_color")
	public List<Color> findAllColors();
	
	//@Select("select co_id,co_name,co_remark,co_status from info_color")
	public List<Color> findColorsPage(PageParam pageParam);

	@Insert("insert into info_color(co_id,co_name,co_remark,co_status) values(#{co_id},#{co_name},#{co_remark},#{co_status})")
	public int insertColor(ColorDto dto);

	
	public int updateColor(ColorDto dto);

	
	@Select("select co_id,co_name,co_remark,co_status from info_color where co_id=#{co_id}")
	public Color findColorbyId(String co_id);

	public int deleteColorByIds(Integer... co_ids);

}
